$datum=date("Y")."-".date("m")."-".date("d");
$query="SELECT * , COUNT( * ) FROM twiturl_visits WHERE timestamp LIKE '$datum%' GROUP BY url_id ORDER BY COUNT( * ) DESC LIMIT 0,1";
$tmp_query=mysql_query("$query");
while ($row = mysql_fetch_array($tmp_query)) {
$url_count=$row["COUNT( * )"];
$url_id=$row["url_id"];
}
$tmp_query=mysql_query("SELECT * FROM twiturl_urls WHERE id LIKE '$url_id' AND hide LIKE '0'");
while ($row = mysql_fetch_array($tmp_query)) {
$url_url=$row["url"];
$url_code=$row["code"];
}
$url_datum=date("U");
$url_neuesdatum=strftime("%d. %B %Y",$url_datum);
?>